package servlet;

import Dao.JdbcTools;
import model.Student;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.lang.reflect.InvocationTargetException;
import java.sql.SQLException;
import java.util.List;
@WebServlet("/insertok")
public class insertok extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        this.doPost(req, resp);
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        resp.setContentType("text/html;charset=utf-8");
        String name = req.getParameter("name");
        String sex = req.getParameter("sex");
        String age = req.getParameter("age");
        String major = req.getParameter("major");

        try {
            int i = JdbcTools.update1("insert into student values(null,?,?,?,?,null)",name,sex,age,major);
        if (i > 0) {
            //获取数据库中展示数据
            List<Student> stulist = null;
            try {
                stulist = JdbcTools.queryBeanList("select * from student", Student.class);
                //数据展示 servlet
                req.setAttribute("stulist", stulist);
                req.getRequestDispatcher("showlist").forward(req, resp);
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            } catch (InstantiationException e) {
                e.printStackTrace();
            } catch (IllegalAccessException e) {
                e.printStackTrace();
            } catch (InvocationTargetException e) {
                e.printStackTrace();
            }

        }
    } catch (SQLException throwables) {
        throwables.printStackTrace();
    }

    }
}
